<?php
error_reporting(E_ALL);
ini_set('mssql.datetimeconvert', 0);
function tmssql() {
    print "<h3>mssql</h3>";
    $db = mssql_connect('JAGUAR\vsdotnet', 'adodb', 'natsoft') or die('No Connection');
    mssql_select_db('northwind', $db);

    $rs = mssql_query('select getdate() as date', $db);
    $o = mssql_fetch_row($rs);
    print_r($o);
    mssql_free_result($rs);

    print "<p>Delete</p>";
    flush();
    $rs2 = mssql_query('delete from adoxyz', $db);
    $p = mssql_num_rows($rs2);
    mssql_free_result($rs2);
}

function tpear() {
    include_once('DB.php');

    print "<h3>PEAR</h3>";
    $username = 'adodb';
    $password = 'natsoft';
    $hostname = 'JAGUAR\vsdotnet';
    $databasename = 'northwind';

    $dsn = "mssql://$username:$password@$hostname/$databasename";
    $conn = DB::connect($dsn);
    print "date=" . $conn->GetOne('select getdate()') . "<br>";
    @$conn->query('create table tester (id integer)');
    print "<p>Delete</p>";
    flush();
    $rs = $conn->query('delete from tester');
    print "date=" . $conn->GetOne('select getdate()') . "<br>";
}

function tadodb() {
    include_once('../adodb.inc.php');

    print "<h3>ADOdb</h3>";
    $conn = NewADOConnection('mssql');
    $conn->Connect('JAGUAR\vsdotnet', 'adodb', 'natsoft', 'northwind');
//	$conn->debug=1;
    print "date=" . $conn->GetOne('select getdate()') . "<br>";
    $conn->Execute('create table tester (id integer)');
    print "<p>Delete</p>";
    flush();
    $rs = $conn->Execute('delete from tester');
    print "date=" . $conn->GetOne('select getdate()') . "<br>";
}

$ACCEPTIP = '127.0.0.1';

$remote = $_SERVER["REMOTE_ADDR"];

if (!empty($ACCEPTIP))
    if ($remote != '127.0.0.1' && $remote != $ACCEPTIP)
        die("Unauthorised client: '$remote'");
?>
<a href=tmssql.php?do=tmssql>mssql</a>
<a href=tmssql.php?do=tpear>pear</a>
<a href=tmssql.php?do=tadodb>adodb</a>
<?php
if (!empty($_GET['do'])) {
    $do = $_GET['do'];
    switch ($do) {
        case 'tpear':
        case 'tadodb':
        case 'tmssql':
            $do();
    }
}
?>